package com.shop.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shop.entity.SupplierCouriers;
import com.shop.entity.SupplierWarehouse;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * yyt(SupplierWarehouse)表数据库访问层
 *
 * @author makejava
 * @since 2020-11-21 10:12:57
 */
@Mapper
public interface SupplierWarehouseMapper extends BaseMapper<SupplierWarehouse> {


    int insertSelective(SupplierWarehouse supplierWarehouse);

    int updateById(SupplierWarehouse updated);

    int deleteById(@Param("id")Integer id);

    List<SupplierWarehouse> searchSomeByPage(@Param("superSearchKeyWord") String superSearchKeyWord, @Param("supplierWarehouse") SupplierWarehouse supplierWarehouse);

    @Select("select * from supplier_couriers where warehouse_id=#{id}")
    List<SupplierCouriers> getDeliveryListByWarehouseId(Integer id);

    List<SupplierWarehouse> queryAll();


}
